﻿/**
* File: XmglxmxxDbModel.cs
* Author: 汪杰
* Create Time:2025/2/21 13:53:00
* Email:15200358008@139.com
* 代码由TMCodeGenerator自动生成
**/
using System;
using SqlSugar;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;

namespace JSLCloud.DBModel
{
    /// <summary>
    /// xm_gl_xmxx Db Model
    /// </summary>
    [SugarTable("xm_gl_xmxx")]
    public class XmglxmxxDbModel
    {
        /// <summary>
        /// ID
        /// </summary>
        [SugarColumn(IsPrimaryKey = true , ColumnName = "ID" , IsIdentity = true)]
        public int ID { get; set; }
        
        /// <summary>
        /// 创建人ID
        /// </summary>
        [SugarColumn(ColumnName = "CREATEID")]
        public int? Createid { get; set; }
        
        /// <summary>
        /// 创建人姓名
        /// </summary>
        [SugarColumn(ColumnName = "CREATENAME")]
        public string Createname { get; set; }
        
        /// <summary>
        /// 创建时间
        /// </summary>
        [SugarColumn(ColumnName = "CREATETIME")]
        public DateTime? Createtime { get; set; }
        
        /// <summary>
        /// 修改人ID
        /// </summary>
        [SugarColumn(ColumnName = "UPDATEID")]
        public int? Updateid { get; set; }
        
        /// <summary>
        /// 修改人姓名
        /// </summary>
        [SugarColumn(ColumnName = "UPDATENAME")]
        public string Updatename { get; set; }
        
        /// <summary>
        /// 修改时间
        /// </summary>
        [SugarColumn(ColumnName = "UPDATETIME")]
        public DateTime? Updatetime { get; set; }
        
        /// <summary>
        /// 删除标识 0未删除 1已删除
        /// </summary>
        [SugarColumn(ColumnName = "DELETEFLAG")]
        public int Deleteflag { get; set; }
        
        /// <summary>
        /// 客户ID
        /// </summary>
        [SugarColumn(ColumnName = "KHID")]
        public int Khid { get; set; }
        
        /// <summary>
        /// 体系ID
        /// </summary>
        [SugarColumn(ColumnName = "TXID")]
        public int Txid { get; set; }
        
        /// <summary>
        /// ERP编号
        /// </summary>
        [SugarColumn(ColumnName = "ERPBH")]
        public string Erpbh { get; set; }
        
        /// <summary>
        /// 市县区
        /// </summary>
        [SugarColumn(ColumnName = "SXQ")]
        public string Sxq { get; set; }
        
        /// <summary>
        /// 审核类型  初审 再认证 监督一 监督二
        /// </summary>
        [SugarColumn(ColumnName = "SHLX")]
        public string Shlx { get; set; }
        
        /// <summary>
        /// 体系人数
        /// </summary>
        [SugarColumn(ColumnName = "TXRS")]
        public int Txrs { get; set; }
        
        /// <summary>
        /// 认证范围
        /// </summary>
        [SugarColumn(ColumnName = "RZFW")]
        public string Rzfw { get; set; }
        
        /// <summary>
        /// 初审金额
        /// </summary>
        [SugarColumn(ColumnName = "CSJE")]
        public decimal Csje { get; set; }
        
        /// <summary>
        /// 监审金额
        /// </summary>
        [SugarColumn(ColumnName = "JSJE")]
        public decimal Jsje { get; set; }

        /// <summary>
        /// 合同金额
        /// </summary>
        [SugarColumn(ColumnName = "HTJE")]
        public decimal Htje { get; set; }

        /// <summary>
        /// 合同签单日期
        /// </summary>
        [SugarColumn(ColumnName = "HTQDRQ")]
        public DateTime Htqdrq { get; set; }
        
        /// <summary>
        /// 备注说明
        /// </summary>
        [SugarColumn(ColumnName = "BZ")]
        public string Bz { get; set; }

        /// <summary>
        /// 审核人
        /// </summary>
        [SugarColumn(ColumnName = "SHR")]
        public string Shr { get; set; }

        /// <summary>
        /// 审核状态
        /// </summary>
        [SugarColumn(ColumnName = "SHZT")]
        public string Shzt { get; set; }

        /// <summary>
        /// 审核时间
        /// </summary>
        [SugarColumn(ColumnName = "SHSJ")]
        public DateTime? Shsj { get; set; }

        /// <summary>
        /// 排程审核人
        /// </summary>
        [SugarColumn(ColumnName = "PCSHR")]
        public string Pcshr { get; set; }

        /// <summary>
        /// 排程审核状态
        /// </summary>
        [SugarColumn(ColumnName = "PCSHZT")]
        public string Pcshzt { get; set; }

        /// <summary>
        /// 排程审核时间
        /// </summary>
        [SugarColumn(ColumnName = "PCSHSJ")]
        public DateTime? Pcshsj { get; set; }

        /// <summary>
        /// 排程状态
        /// </summary>
        [SugarColumn(ColumnName = "PCZT")]
        public string Pczt { get; set; }

        /// <summary>
        /// 状态状态
        /// </summary>
        [SugarColumn(ColumnName = "XMZT")]
        public string Xmzt { get; set; }

        /// <summary>
        /// 项目状态确认人
        /// </summary>
        [SugarColumn(ColumnName = "XMZTQRR")]
        public string Xmztqrr { get; set; }

        /// <summary>
        /// 项目状态确认时间
        /// </summary>
        [SugarColumn(ColumnName = "XMZTQRSJ")]
        public DateTime? Xmztqrsj { get; set; }

        /// <summary>
        /// 状态状态
        /// </summary>
        [SugarColumn(ColumnName = "SKZT")]
        public string Skzt { get; set; }

        /// <summary>
        /// 收款确认人
        /// </summary>
        [SugarColumn(ColumnName = "SKQRR")]
        public string Skqrr { get; set; }

        /// <summary>
        /// 收款确认时间
        /// </summary>
        [SugarColumn(ColumnName = "SKQRSJ")]
        public DateTime? Skqrsj { get; set; }

        /// <summary>
        /// 状态状态
        /// </summary>
        [SugarColumn(ColumnName = "KPZT")]
        public string Kpzt { get; set; }

        /// <summary>
        /// 收款确认人
        /// </summary>
        [SugarColumn(ColumnName = "KPQRR")]
        public string Kpqrr { get; set; }

        /// <summary>
        /// 收款确认时间
        /// </summary>
        [SugarColumn(ColumnName = "KPQRSJ")]
        public DateTime? Kpqrsj { get; set; }

        /// <summary>
        /// 是否多场所
        /// </summary>
        [SugarColumn(ColumnName = "SFDCS")]
        public string Sfdcs { get; set; }
        /// <summary>
        /// 多场所类别
        /// </summary>
        [SugarColumn(ColumnName = "DCSLB")]
        public string Dcslb { get; set; }
        /// <summary>
        /// 证书号
        /// </summary>
        [SugarColumn(ColumnName = "ZSH")]
        public string Zsh { get; set; }
        /// <summary>
        /// 证书类别
        /// </summary>
        [SugarColumn(ColumnName = "ZSLB")]
        public string Zslb { get; set; }
        /// <summary>
        /// 专业代码
        /// </summary>
        [SugarColumn(ColumnName = "ZYDM")]
        public string Zydm { get; set; }
        /// <summary>
        /// 证书开始日期
        /// </summary>
        [SugarColumn(ColumnName = "ZSKSRQ")]
        public DateTime? Zsksrq { get; set; }
        /// <summary>
        /// 证书结束日期
        /// </summary>
        [SugarColumn(ColumnName = "ZSJSRQ")]
        public DateTime? Zsjsrq { get; set; }
        /// <summary>
        /// 合同类型
        /// </summary>
        [SugarColumn(ColumnName = "HTLX")]
        public string Htlx { get; set; }
        /// <summary>
        /// 合同地址
        /// </summary>
        [SugarColumn(ColumnName = "HTDZ")]
        public string Htdz { get; set; }

        /// <summary>
        /// 末次审核日期
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public DateTime? Mcshrq { get; set; }

        /// <summary>
        /// 审核序号 ，0 初认证、扩大、证书变更、再认证 1监督一 2 监督二
        /// </summary>
        [SugarColumn(ColumnName = "SHXH")]
        public int? Shxh { get; set; } = 0;

        /// <summary>
        /// 省份
        /// </summary>
        [SugarColumn(ColumnName = "SF")]
        public string Sf { get; set; }

        /// <summary>
        /// 流程模板
        /// </summary>
        [SugarColumn(ColumnName = "LCMB")]
        public int? Lcmb { get; set; }

        /// <summary>
        /// 渠道ID
        /// </summary>
        [SugarColumn(ColumnName = "QDID")]
        public int? Qdid { get; set; }

        /// <summary>
        /// 多体系
        /// </summary>
        [SugarColumn(ColumnName = "TXIDS")]
        public string Txids { get; set; }
    }
}
